Japanese Cities' Names - SELECT the name column
Author: Al-mamun Sarkar
Date: 2020-03-26 15:27:43
SQL Select Query - Select the name column. Show the name column of the JPN from the city table. This is the solution to the HackerRank Japanese Cities' Names SQL problem.
Table Name: CITY
Table structure:
Field | Type |
ID | NUMBER |
NAME | VARCHAR |
COUNTRYCODE | VARCHAR |
DISTRICT | VARCHAR |
POPULATION | NUMBER |
SQL Query:
SELECT NAME FROM CITY
WHERE COUNTRYCODE = 'JPN';